/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50728
 Source Host           : localhost:3306
 Source Schema         : eladmin

 Target Server Type    : MySQL
 Target Server Version : 50728
 File Encoding         : 65001

 Date: 07/08/2020 18:38:41
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for code_column_config
-- ----------------------------
DROP TABLE IF EXISTS `code_column_config`;
CREATE TABLE `code_column_config` (
  `column_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `table_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `column_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `column_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dict_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `extra` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `form_show` bit(1) DEFAULT NULL,
  `form_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `key_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `list_show` bit(1) DEFAULT NULL,
  `not_null` bit(1) DEFAULT NULL,
  `query_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_annotation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`column_id`) USING BTREE,
  KEY `idx_table_name` (`table_name`)
) ENGINE=InnoDB AUTO_INCREMENT=282 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='代码生成字段信息存储';

-- ----------------------------
-- Records of code_column_config
-- ----------------------------
BEGIN;
INSERT INTO `code_column_config` VALUES (1, 'gen_test', 'id', 'int', NULL, 'auto_increment', b'0', NULL, 'PRI', b'0', b'1', NULL, 'ID', NULL);
INSERT INTO `code_column_config` VALUES (2, 'gen_test', 'sex', 'int', NULL, '', b'1', NULL, '', b'1', b'0', 'NotNull', '性别', NULL);
INSERT INTO `code_column_config` VALUES (3, 'gen_test', 'create_time', 'datetime', NULL, '', b'0', NULL, '', b'1', b'0', 'BetWeen', '', NULL);
INSERT INTO `code_column_config` VALUES (139, 'quartz_log', 'id', 'bigint', NULL, 'auto_increment', b'1', NULL, 'PRI', b'1', b'0', NULL, '', NULL);
INSERT INTO `code_column_config` VALUES (140, 'quartz_log', 'baen_name', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '', NULL);
INSERT INTO `code_column_config` VALUES (141, 'quartz_log', 'create_time', 'datetime', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '', NULL);
INSERT INTO `code_column_config` VALUES (142, 'quartz_log', 'cron_expression', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '', NULL);
INSERT INTO `code_column_config` VALUES (143, 'quartz_log', 'exception_detail', 'text', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '', NULL);
INSERT INTO `code_column_config` VALUES (144, 'quartz_log', 'is_success', 'bit', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '', NULL);
INSERT INTO `code_column_config` VALUES (145, 'quartz_log', 'job_name', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '', NULL);
INSERT INTO `code_column_config` VALUES (146, 'quartz_log', 'method_name', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '', NULL);
INSERT INTO `code_column_config` VALUES (147, 'quartz_log', 'params', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '', NULL);
INSERT INTO `code_column_config` VALUES (148, 'quartz_log', 'time', 'bigint', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '', NULL);
INSERT INTO `code_column_config` VALUES (149, 'quartz_log', 'result', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '', NULL);
INSERT INTO `code_column_config` VALUES (150, 'order_detail', 'id', 'bigint', NULL, 'auto_increment', b'1', NULL, 'PRI', b'1', b'0', NULL, '主键', NULL);
INSERT INTO `code_column_config` VALUES (151, 'order_detail', 'master_id', 'bigint', NULL, '', b'1', NULL, '', b'1', b'0', '=', '订单主表ID', NULL);
INSERT INTO `code_column_config` VALUES (152, 'order_detail', 'model', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '型号', NULL);
INSERT INTO `code_column_config` VALUES (153, 'order_detail', 'color', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '颜色', NULL);
INSERT INTO `code_column_config` VALUES (154, 'order_detail', 'size', 'char', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '尺码', NULL);
INSERT INTO `code_column_config` VALUES (155, 'order_detail', 'style', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '男女款', NULL);
INSERT INTO `code_column_config` VALUES (156, 'order_detail', 'quantity', 'tinyint', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '件数', NULL);
INSERT INTO `code_column_config` VALUES (157, 'order_detail', 'unit_price', 'double', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '单价', NULL);
INSERT INTO `code_column_config` VALUES (158, 'order_detail', 'total_price', 'double', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '总价', NULL);
INSERT INTO `code_column_config` VALUES (159, 'stock', 'id', 'bigint', NULL, 'auto_increment', b'1', NULL, 'PRI', b'1', b'0', NULL, '主键', NULL);
INSERT INTO `code_column_config` VALUES (160, 'stock', 'model', 'varchar', NULL, '', b'1', 'Select', '', b'1', b'0', '=', '型号', NULL);
INSERT INTO `code_column_config` VALUES (161, 'stock', 'color', 'varchar', NULL, '', b'1', 'Select', '', b'1', b'0', '=', '颜色', NULL);
INSERT INTO `code_column_config` VALUES (162, 'stock', 'size', 'char', NULL, '', b'1', 'Select', '', b'1', b'0', '=', '尺码', NULL);
INSERT INTO `code_column_config` VALUES (163, 'stock', 'style', 'varchar', NULL, '', b'1', 'Select', '', b'1', b'0', '=', '男女款', NULL);
INSERT INTO `code_column_config` VALUES (164, 'stock', 'total_quantity', 'tinyint', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '件数', NULL);
INSERT INTO `code_column_config` VALUES (165, 'stock', 'sold_quantity', 'tinyint', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '卖出的数量', NULL);
INSERT INTO `code_column_config` VALUES (166, 'order_master', 'id', 'bigint', NULL, 'auto_increment', b'1', NULL, 'PRI', b'1', b'0', NULL, '主键', NULL);
INSERT INTO `code_column_config` VALUES (167, 'order_master', 'order_date', 'date', NULL, '', b'1', NULL, '', b'1', b'0', '=', '下单时间', NULL);
INSERT INTO `code_column_config` VALUES (168, 'order_master', 'quantity', 'tinyint', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '件数', NULL);
INSERT INTO `code_column_config` VALUES (169, 'order_master', 'total_price', 'double', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '总价', NULL);
INSERT INTO `code_column_config` VALUES (170, 'order_master', 'postage', 'double', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '邮费', NULL);
INSERT INTO `code_column_config` VALUES (171, 'order_master', 'postage_direct', 'double', NULL, '', b'1', NULL, '', b'1', b'0', '=', '0:不需快递；1：寄方支付；2：收方支付', NULL);
INSERT INTO `code_column_config` VALUES (172, 'order_master', 'express', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '物流公司', NULL);
INSERT INTO `code_column_config` VALUES (173, 'order_master', 'express_number', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '物流单号', NULL);
INSERT INTO `code_column_config` VALUES (174, 'order_master', 'send_off', 'tinyint', NULL, '', b'1', NULL, '', b'1', b'0', '=', '是否发货', NULL);
INSERT INTO `code_column_config` VALUES (175, 'order_master', 'memo', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '备注', NULL);
INSERT INTO `code_column_config` VALUES (176, 'code_column_config', 'column_id', 'bigint', NULL, 'auto_increment', b'1', NULL, 'PRI', b'1', b'0', NULL, 'ID', NULL);
INSERT INTO `code_column_config` VALUES (177, 'code_column_config', 'table_name', 'varchar', NULL, '', b'1', NULL, 'MUL', b'1', b'0', NULL, '', NULL);
INSERT INTO `code_column_config` VALUES (178, 'code_column_config', 'column_name', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '', NULL);
INSERT INTO `code_column_config` VALUES (179, 'code_column_config', 'column_type', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '', NULL);
INSERT INTO `code_column_config` VALUES (180, 'code_column_config', 'dict_name', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '', NULL);
INSERT INTO `code_column_config` VALUES (181, 'code_column_config', 'extra', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '', NULL);
INSERT INTO `code_column_config` VALUES (182, 'code_column_config', 'form_show', 'bit', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '', NULL);
INSERT INTO `code_column_config` VALUES (183, 'code_column_config', 'form_type', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '', NULL);
INSERT INTO `code_column_config` VALUES (184, 'code_column_config', 'key_type', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '', NULL);
INSERT INTO `code_column_config` VALUES (185, 'code_column_config', 'list_show', 'bit', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '', NULL);
INSERT INTO `code_column_config` VALUES (186, 'code_column_config', 'not_null', 'bit', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '', NULL);
INSERT INTO `code_column_config` VALUES (187, 'code_column_config', 'query_type', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '', NULL);
INSERT INTO `code_column_config` VALUES (188, 'code_column_config', 'remark', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '', NULL);
INSERT INTO `code_column_config` VALUES (189, 'code_column_config', 'date_annotation', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '', NULL);
INSERT INTO `code_column_config` VALUES (190, 'sys_role', 'role_id', 'bigint', NULL, 'auto_increment', b'1', NULL, 'PRI', b'1', b'0', NULL, 'ID', NULL);
INSERT INTO `code_column_config` VALUES (191, 'sys_role', 'name', 'varchar', NULL, '', b'1', NULL, 'UNI', b'1', b'1', NULL, '名称', NULL);
INSERT INTO `code_column_config` VALUES (192, 'sys_role', 'description', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '描述', NULL);
INSERT INTO `code_column_config` VALUES (193, 'sys_role', 'data_scope', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '数据权限', NULL);
INSERT INTO `code_column_config` VALUES (194, 'sys_role', 'level', 'int', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '角色级别', NULL);
INSERT INTO `code_column_config` VALUES (195, 'sys_role', 'create_time', 'datetime', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '创建日期', NULL);
INSERT INTO `code_column_config` VALUES (196, 'sys_role', 'update_by', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '更新者', NULL);
INSERT INTO `code_column_config` VALUES (197, 'sys_role', 'create_by', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '创建者', NULL);
INSERT INTO `code_column_config` VALUES (198, 'sys_role', 'update_time', 'datetime', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '更新时间', NULL);
INSERT INTO `code_column_config` VALUES (199, 'mnt_server', 'server_id', 'bigint', NULL, 'auto_increment', b'1', NULL, 'PRI', b'1', b'0', NULL, 'ID', NULL);
INSERT INTO `code_column_config` VALUES (200, 'mnt_server', 'account', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '账号', NULL);
INSERT INTO `code_column_config` VALUES (201, 'mnt_server', 'ip', 'varchar', NULL, '', b'1', NULL, 'MUL', b'1', b'0', NULL, 'IP地址', NULL);
INSERT INTO `code_column_config` VALUES (202, 'mnt_server', 'name', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '名称', NULL);
INSERT INTO `code_column_config` VALUES (203, 'mnt_server', 'password', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '密码', NULL);
INSERT INTO `code_column_config` VALUES (204, 'mnt_server', 'port', 'int', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '端口', NULL);
INSERT INTO `code_column_config` VALUES (205, 'mnt_server', 'create_time', 'datetime', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '', NULL);
INSERT INTO `code_column_config` VALUES (206, 'mnt_server', 'create_by', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '创建者', NULL);
INSERT INTO `code_column_config` VALUES (207, 'mnt_server', 'update_by', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '更新者', NULL);
INSERT INTO `code_column_config` VALUES (208, 'mnt_server', 'update_time', 'datetime', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '更新时间', NULL);
INSERT INTO `code_column_config` VALUES (209, 'sys_menu', 'menu_id', 'bigint', NULL, 'auto_increment', b'1', NULL, 'PRI', b'1', b'0', NULL, 'ID', NULL);
INSERT INTO `code_column_config` VALUES (210, 'sys_menu', 'i_frame', 'bit', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '是否外链', NULL);
INSERT INTO `code_column_config` VALUES (211, 'sys_menu', 'title', 'varchar', NULL, '', b'1', NULL, 'UNI', b'1', b'0', NULL, '菜单标题', NULL);
INSERT INTO `code_column_config` VALUES (212, 'sys_menu', 'component', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '组件', NULL);
INSERT INTO `code_column_config` VALUES (213, 'sys_menu', 'pid', 'bigint', NULL, '', b'1', NULL, 'MUL', b'1', b'0', NULL, '', NULL);
INSERT INTO `code_column_config` VALUES (214, 'sys_menu', 'menu_sort', 'int', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '排序', NULL);
INSERT INTO `code_column_config` VALUES (215, 'sys_menu', 'icon', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '图标', NULL);
INSERT INTO `code_column_config` VALUES (216, 'sys_menu', 'path', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '链接地址', NULL);
INSERT INTO `code_column_config` VALUES (217, 'sys_menu', 'cache', 'bit', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '缓存', NULL);
INSERT INTO `code_column_config` VALUES (218, 'sys_menu', 'hidden', 'bit', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '隐藏', NULL);
INSERT INTO `code_column_config` VALUES (219, 'sys_menu', 'name', 'varchar', NULL, '', b'1', NULL, 'UNI', b'1', b'0', NULL, '组件名称', NULL);
INSERT INTO `code_column_config` VALUES (220, 'sys_menu', 'create_time', 'datetime', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '创建日期', NULL);
INSERT INTO `code_column_config` VALUES (221, 'sys_menu', 'permission', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '权限', NULL);
INSERT INTO `code_column_config` VALUES (222, 'sys_menu', 'type', 'int', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '类型', NULL);
INSERT INTO `code_column_config` VALUES (223, 'sys_menu', 'sub_count', 'int', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '子菜单数目', NULL);
INSERT INTO `code_column_config` VALUES (224, 'sys_menu', 'update_by', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '更新者', NULL);
INSERT INTO `code_column_config` VALUES (225, 'sys_menu', 'create_by', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '创建者', NULL);
INSERT INTO `code_column_config` VALUES (226, 'sys_menu', 'update_time', 'datetime', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '更新时间', NULL);
INSERT INTO `code_column_config` VALUES (227, 'sys_users_jobs', 'user_id', 'bigint', NULL, '', b'1', NULL, 'PRI', b'1', b'1', NULL, '用户ID', NULL);
INSERT INTO `code_column_config` VALUES (228, 'sys_users_jobs', 'job_id', 'bigint', NULL, '', b'1', NULL, 'PRI', b'1', b'1', NULL, '岗位ID', NULL);
INSERT INTO `code_column_config` VALUES (229, 'sys_monitor_server', 'monitor_id', 'bigint', NULL, 'auto_increment', b'1', NULL, 'PRI', b'1', b'0', NULL, 'ID', NULL);
INSERT INTO `code_column_config` VALUES (230, 'sys_monitor_server', 'cpu_core', 'int', NULL, '', b'1', NULL, '', b'1', b'0', NULL, 'CPU内核数', NULL);
INSERT INTO `code_column_config` VALUES (231, 'sys_monitor_server', 'cpu_rate', 'double', NULL, '', b'1', NULL, '', b'1', b'0', NULL, 'CPU使用率', NULL);
INSERT INTO `code_column_config` VALUES (232, 'sys_monitor_server', 'disk_total', 'double', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '磁盘总量', NULL);
INSERT INTO `code_column_config` VALUES (233, 'sys_monitor_server', 'disk_used', 'double', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '磁盘使用量', NULL);
INSERT INTO `code_column_config` VALUES (234, 'sys_monitor_server', 'mem_total', 'double', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '内存总数', NULL);
INSERT INTO `code_column_config` VALUES (235, 'sys_monitor_server', 'mem_used', 'double', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '内存使用量', NULL);
INSERT INTO `code_column_config` VALUES (236, 'sys_monitor_server', 'name', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '名称', NULL);
INSERT INTO `code_column_config` VALUES (237, 'sys_monitor_server', 'port', 'int', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '访问端口', NULL);
INSERT INTO `code_column_config` VALUES (238, 'sys_monitor_server', 'monitor_sort', 'int', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '排序', NULL);
INSERT INTO `code_column_config` VALUES (239, 'sys_monitor_server', 'state', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '状态', NULL);
INSERT INTO `code_column_config` VALUES (240, 'sys_monitor_server', 'swap_total', 'double', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '交换区总量', NULL);
INSERT INTO `code_column_config` VALUES (241, 'sys_monitor_server', 'swap_used', 'double', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '交换区使用量', NULL);
INSERT INTO `code_column_config` VALUES (242, 'sys_monitor_server', 'address', 'varchar', NULL, '', b'1', NULL, '', b'1', b'1', NULL, '服务地址', NULL);
INSERT INTO `code_column_config` VALUES (243, 'sys_monitor_server', 'create_by', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '创建者', NULL);
INSERT INTO `code_column_config` VALUES (244, 'sys_monitor_server', 'update_by', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '更新者', NULL);
INSERT INTO `code_column_config` VALUES (245, 'sys_monitor_server', 'create_time', 'datetime', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '创建时间', NULL);
INSERT INTO `code_column_config` VALUES (246, 'sys_monitor_server', 'update_time', 'datetime', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '更新时间', NULL);
INSERT INTO `code_column_config` VALUES (247, 'tool_qiniu_config', 'config_id', 'bigint', NULL, '', b'1', NULL, 'PRI', b'1', b'1', NULL, 'ID', NULL);
INSERT INTO `code_column_config` VALUES (248, 'tool_qiniu_config', 'access_key', 'text', NULL, '', b'1', NULL, '', b'1', b'0', NULL, 'accessKey', NULL);
INSERT INTO `code_column_config` VALUES (249, 'tool_qiniu_config', 'bucket', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, 'Bucket 识别符', NULL);
INSERT INTO `code_column_config` VALUES (250, 'tool_qiniu_config', 'host', 'varchar', NULL, '', b'1', NULL, '', b'1', b'1', NULL, '外链域名', NULL);
INSERT INTO `code_column_config` VALUES (251, 'tool_qiniu_config', 'secret_key', 'text', NULL, '', b'1', NULL, '', b'1', b'0', NULL, 'secretKey', NULL);
INSERT INTO `code_column_config` VALUES (252, 'tool_qiniu_config', 'type', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '空间类型', NULL);
INSERT INTO `code_column_config` VALUES (253, 'tool_qiniu_config', 'zone', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '机房', NULL);
INSERT INTO `code_column_config` VALUES (254, 'tool_local_storage', 'storage_id', 'bigint', NULL, 'auto_increment', b'1', NULL, 'PRI', b'1', b'0', NULL, 'ID', NULL);
INSERT INTO `code_column_config` VALUES (255, 'tool_local_storage', 'real_name', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '文件真实的名称', NULL);
INSERT INTO `code_column_config` VALUES (256, 'tool_local_storage', 'name', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '文件名', NULL);
INSERT INTO `code_column_config` VALUES (257, 'tool_local_storage', 'suffix', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '后缀', NULL);
INSERT INTO `code_column_config` VALUES (258, 'tool_local_storage', 'path', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '路径', NULL);
INSERT INTO `code_column_config` VALUES (259, 'tool_local_storage', 'type', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '类型', NULL);
INSERT INTO `code_column_config` VALUES (260, 'tool_local_storage', 'size', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '大小', NULL);
INSERT INTO `code_column_config` VALUES (261, 'tool_local_storage', 'create_time', 'datetime', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '创建日期', NULL);
INSERT INTO `code_column_config` VALUES (262, 'tool_local_storage', 'create_by', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '创建者', NULL);
INSERT INTO `code_column_config` VALUES (263, 'tool_local_storage', 'update_by', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '更新者', NULL);
INSERT INTO `code_column_config` VALUES (264, 'tool_local_storage', 'update_time', 'datetime', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '更新时间', NULL);
INSERT INTO `code_column_config` VALUES (265, 'tool_email_config', 'config_id', 'bigint', NULL, '', b'1', NULL, 'PRI', b'1', b'1', NULL, 'ID', NULL);
INSERT INTO `code_column_config` VALUES (266, 'tool_email_config', 'from_user', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '收件人', NULL);
INSERT INTO `code_column_config` VALUES (267, 'tool_email_config', 'host', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '邮件服务器SMTP地址', NULL);
INSERT INTO `code_column_config` VALUES (268, 'tool_email_config', 'pass', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '密码', NULL);
INSERT INTO `code_column_config` VALUES (269, 'tool_email_config', 'port', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '端口', NULL);
INSERT INTO `code_column_config` VALUES (270, 'tool_email_config', 'user', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '发件者用户名', NULL);
INSERT INTO `code_column_config` VALUES (271, 'tool_alipay_config', 'config_id', 'bigint', NULL, '', b'1', NULL, 'PRI', b'1', b'1', NULL, 'ID', NULL);
INSERT INTO `code_column_config` VALUES (272, 'tool_alipay_config', 'app_id', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '应用ID', NULL);
INSERT INTO `code_column_config` VALUES (273, 'tool_alipay_config', 'charset', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '编码', NULL);
INSERT INTO `code_column_config` VALUES (274, 'tool_alipay_config', 'format', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '类型 固定格式json', NULL);
INSERT INTO `code_column_config` VALUES (275, 'tool_alipay_config', 'gateway_url', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '网关地址', NULL);
INSERT INTO `code_column_config` VALUES (276, 'tool_alipay_config', 'notify_url', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '异步回调', NULL);
INSERT INTO `code_column_config` VALUES (277, 'tool_alipay_config', 'private_key', 'text', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '私钥', NULL);
INSERT INTO `code_column_config` VALUES (278, 'tool_alipay_config', 'public_key', 'text', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '公钥', NULL);
INSERT INTO `code_column_config` VALUES (279, 'tool_alipay_config', 'return_url', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '回调地址', NULL);
INSERT INTO `code_column_config` VALUES (280, 'tool_alipay_config', 'sign_type', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '签名方式', NULL);
INSERT INTO `code_column_config` VALUES (281, 'tool_alipay_config', 'sys_service_provider_id', 'varchar', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '商户号', NULL);
COMMIT;

-- ----------------------------
-- Table structure for code_gen_config
-- ----------------------------
DROP TABLE IF EXISTS `code_gen_config`;
CREATE TABLE `code_gen_config` (
  `config_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `table_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '表名',
  `author` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '作者',
  `cover` bit(1) DEFAULT NULL COMMENT '是否覆盖',
  `module_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模块名称',
  `pack` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '至于哪个包下',
  `path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '前端代码生成的路径',
  `api_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '前端Api文件路径',
  `prefix` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '表前缀',
  `api_alias` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '接口名称',
  PRIMARY KEY (`config_id`) USING BTREE,
  KEY `idx_table_name` (`table_name`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='代码生成器配置';

-- ----------------------------
-- Records of code_gen_config
-- ----------------------------
BEGIN;
INSERT INTO `code_gen_config` VALUES (3, 'gen_test', 'Zheng Jie', b'1', 'eladmin-system', 'me.zhengjie.gen', 'E:\\workspace\\me\\front\\eladmin-web\\src\\views\\gen', 'E:\\workspace\\me\\front\\eladmin-web\\src\\api', NULL, '测试生成');
INSERT INTO `code_gen_config` VALUES (8, 'stock', 'tec', b'0', 'eladmin-system', 'com.tec.modules.order', 'order/stock', 'order/stock/', NULL, '库存一览');
INSERT INTO `code_gen_config` VALUES (9, 'order_master', 'tec', b'0', 'eladmin-system', 'com.tec.modules.order', 'order/bizOrder', 'order/bizOrder/', NULL, '销售订单');
INSERT INTO `code_gen_config` VALUES (10, 'order_detail', 'tec', b'0', 'eladmin-system', 'com.tec.modules.order', 'order/orderDetail', 'order/orderDetail/', NULL, '订单明细');
COMMIT;

-- ----------------------------
-- Table structure for gen_test
-- ----------------------------
DROP TABLE IF EXISTS `gen_test`;
CREATE TABLE `gen_test` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sex` int(255) DEFAULT NULL COMMENT '性别',
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='代码生成测试';

-- ----------------------------
-- Records of gen_test
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for mnt_app
-- ----------------------------
DROP TABLE IF EXISTS `mnt_app`;
CREATE TABLE `mnt_app` (
  `app_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '应用名称',
  `upload_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '上传目录',
  `deploy_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '部署路径',
  `backup_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备份路径',
  `port` int(255) DEFAULT NULL COMMENT '应用端口',
  `start_script` varchar(4000) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '启动脚本',
  `deploy_script` varchar(4000) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '部署脚本',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `create_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`app_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='应用管理';

-- ----------------------------
-- Records of mnt_app
-- ----------------------------
BEGIN;
INSERT INTO `mnt_app` VALUES (1, 'eladmin-monitor-2.4.jar', '/opt/upload', '/opt/monitor', '/opt/backup', 8777, 'cd /opt/monitor\nnohup java -jar eladmin-monitor-2.4.jar >nohup.out 2>&1 &', 'mv -f /opt/upload/eladmin-monitor-2.4.jar /opt/monitor\ncd /opt/monitor\nnohup java -jar eladmin-monitor-2.4.jar >nohup.out 2>&1 &', '2019-11-24 20:52:59', NULL, NULL, NULL);
INSERT INTO `mnt_app` VALUES (2, 'eladmin-system-2.3.jar', '/opt/upload', '/opt/eladmin', '/opt/backup/eladmin', 8000, 'cd /opt/eladmin\nnohup java -jar eladmin-system-2.3.jar --spring.profiles.active=prod >nohup.out 2>&1 &', 'mv -f /opt/upload/eladmin-system-2.3.jar /opt/eladmin/\ncd /opt/eladmin\nnohup java -jar eladmin-system-2.3.jar --spring.profiles.active=prod >nohup.out 2>&1 &', '2019-12-21 16:39:57', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for mnt_database
-- ----------------------------
DROP TABLE IF EXISTS `mnt_database`;
CREATE TABLE `mnt_database` (
  `db_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'ID',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '名称',
  `jdbc_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'jdbc连接',
  `user_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '账号',
  `pwd` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '密码',
  `create_time` datetime DEFAULT NULL,
  `create_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`db_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='数据库管理';

-- ----------------------------
-- Records of mnt_database
-- ----------------------------
BEGIN;
INSERT INTO `mnt_database` VALUES ('c4109eefc5724c65857ca9dd2690e0dd', 'eladmin', 'jdbc:mysql://localhost:3306/eladmin?serverTimezone=Asia/Shanghai', 'root', '123456', '2019-12-21 21:11:17', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for mnt_deploy
-- ----------------------------
DROP TABLE IF EXISTS `mnt_deploy`;
CREATE TABLE `mnt_deploy` (
  `deploy_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `app_id` bigint(20) DEFAULT NULL COMMENT '应用编号',
  `create_time` datetime DEFAULT NULL,
  `create_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`deploy_id`) USING BTREE,
  KEY `FK6sy157pseoxx4fmcqr1vnvvhy` (`app_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='部署管理';

-- ----------------------------
-- Records of mnt_deploy
-- ----------------------------
BEGIN;
INSERT INTO `mnt_deploy` VALUES (3, 1, '2019-12-21 15:53:06', NULL, NULL, NULL);
INSERT INTO `mnt_deploy` VALUES (6, 2, '2019-12-21 17:09:02', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for mnt_deploy_history
-- ----------------------------
DROP TABLE IF EXISTS `mnt_deploy_history`;
CREATE TABLE `mnt_deploy_history` (
  `history_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'ID',
  `app_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '应用名称',
  `deploy_date` datetime NOT NULL COMMENT '部署日期',
  `deploy_user` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '部署用户',
  `ip` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '服务器IP',
  `deploy_id` bigint(20) DEFAULT NULL COMMENT '部署编号',
  PRIMARY KEY (`history_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='部署历史管理';

-- ----------------------------
-- Records of mnt_deploy_history
-- ----------------------------
BEGIN;
INSERT INTO `mnt_deploy_history` VALUES ('4ee0edd1f3b648a396280a542d72c121', 'eladmin-monitor-2.4.jar', '2019-12-22 13:06:07', 'admin', '132.232.129.20', 3);
INSERT INTO `mnt_deploy_history` VALUES ('4fd432a128c947ccae55316b3d5dcd7b', 'eladmin-monitor-2.4.jar', '2019-12-22 13:49:09', 'admin', '132.232.129.20', 3);
INSERT INTO `mnt_deploy_history` VALUES ('cfda21f48da341b396657af94554c890', 'eladmin-monitor-2.4.jar', '2019-12-22 13:08:22', 'admin', '132.232.129.20', 3);
COMMIT;

-- ----------------------------
-- Table structure for mnt_deploy_server
-- ----------------------------
DROP TABLE IF EXISTS `mnt_deploy_server`;
CREATE TABLE `mnt_deploy_server` (
  `deploy_id` bigint(20) NOT NULL,
  `server_id` bigint(20) NOT NULL,
  PRIMARY KEY (`deploy_id`,`server_id`) USING BTREE,
  KEY `FKeaaha7jew9a02b3bk9ghols53` (`server_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='应用与服务器关联';

-- ----------------------------
-- Records of mnt_deploy_server
-- ----------------------------
BEGIN;
INSERT INTO `mnt_deploy_server` VALUES (3, 1);
INSERT INTO `mnt_deploy_server` VALUES (6, 1);
COMMIT;

-- ----------------------------
-- Table structure for mnt_server
-- ----------------------------
DROP TABLE IF EXISTS `mnt_server`;
CREATE TABLE `mnt_server` (
  `server_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `account` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '账号',
  `ip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'IP地址',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名称',
  `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '密码',
  `port` int(11) DEFAULT NULL COMMENT '端口',
  `create_time` datetime DEFAULT NULL,
  `create_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`server_id`) USING BTREE,
  KEY `idx_ip` (`ip`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='服务器管理';

-- ----------------------------
-- Records of mnt_server
-- ----------------------------
BEGIN;
INSERT INTO `mnt_server` VALUES (1, 'root', '132.232.129.20', '腾讯云', 'Dqjdda1996.', 8013, '2019-11-24 20:35:02', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for order_detail
-- ----------------------------
DROP TABLE IF EXISTS `order_detail`;
CREATE TABLE `order_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `master_id` bigint(20) DEFAULT NULL COMMENT '订单主表ID',
  `model` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '型号',
  `color` varchar(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '颜色',
  `size` char(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '尺码',
  `style` varchar(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '男女款',
  `quantity` tinyint(4) DEFAULT NULL COMMENT '件数',
  `unit_price` double DEFAULT NULL COMMENT '单价',
  `total_price` double DEFAULT NULL COMMENT '总价',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='订单明细表';

-- ----------------------------
-- Records of order_detail
-- ----------------------------
BEGIN;
INSERT INTO `order_detail` VALUES (1, 1, '', '', '', '', 4, 25, 100);
INSERT INTO `order_detail` VALUES (2, 2, 'ATSM353-1紧身型', '蓝色', 'L', '男款', 1, 50, 50);
INSERT INTO `order_detail` VALUES (3, 2, 'ATSM353-1紧身型', '蓝色', '3XL', '男款', 1, 50, 50);
INSERT INTO `order_detail` VALUES (4, 3, 'ATSM353-1紧身型', '蓝色', 'L', '男款', 8, 40, 320);
INSERT INTO `order_detail` VALUES (5, 3, 'ATSM246-1', '粉色', 'L', '女款', 2, 40, 80);
INSERT INTO `order_detail` VALUES (6, 4, 'ATSM353-1紧身型', '蓝色', 'L', '男款', 1, 50, 50);
INSERT INTO `order_detail` VALUES (7, 5, 'ATSM353-1紧身型', '蓝色', 'L', '男款', 1, 45, 45);
COMMIT;

-- ----------------------------
-- Table structure for order_master
-- ----------------------------
DROP TABLE IF EXISTS `order_master`;
CREATE TABLE `order_master` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `order_date` datetime DEFAULT NULL COMMENT '下单时间',
  `quantity` tinyint(4) DEFAULT NULL COMMENT '件数',
  `total_price` double DEFAULT NULL COMMENT '总价',
  `postage` double DEFAULT NULL COMMENT '邮费',
  `postage_direct` double DEFAULT '2' COMMENT '1:不需快递；2：寄方支付；3：收方支付',
  `express` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '物流公司',
  `express_number` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '物流单号',
  `send_off` tinyint(1) DEFAULT NULL COMMENT '是否发货',
  `memo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='订单主表';

-- ----------------------------
-- Records of order_master
-- ----------------------------
BEGIN;
INSERT INTO `order_master` VALUES (1, '2020-05-02 00:00:00', 4, 100, 0, 1, NULL, NULL, 1, '雪山寺内部销售4件');
INSERT INTO `order_master` VALUES (2, '2020-05-21 00:00:00', 2, 100, 13, 2, '京东物流', 'JDX001753350001', 1, '哈尔滨买家下单购买，电话确认尺码颜色时，加购一件，微信转账。');
INSERT INTO `order_master` VALUES (3, '2020-05-24 00:00:00', 10, 400, 13, 2, '京东物流', 'JDX001762663352', 1, '哈尔滨买家重复购买。');
INSERT INTO `order_master` VALUES (4, '2020-05-26 00:00:00', 1, 50, 9, 2, '京东物流', 'JDX001772273543', 1, '临沂买家下单购买。');
INSERT INTO `order_master` VALUES (5, '2020-07-23 00:00:00', 1, 45, 14, 2, '京东物流', 'JDX002190245659', 1, '云南买家下单购买。');
COMMIT;

-- ----------------------------
-- Table structure for stock
-- ----------------------------
DROP TABLE IF EXISTS `stock`;
CREATE TABLE `stock` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `model` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '型号',
  `color` varchar(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '颜色',
  `size` char(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '尺码',
  `style` varchar(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '男女款',
  `total_quantity` tinyint(4) DEFAULT NULL COMMENT '件数',
  `sold_quantity` tinyint(4) DEFAULT NULL COMMENT '卖出的数量',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='商品库存';

-- ----------------------------
-- Records of stock
-- ----------------------------
BEGIN;
INSERT INTO `stock` VALUES (1, 'ATSM353-1紧身型', '蓝色', '3XL', '男款', 14, 1);
INSERT INTO `stock` VALUES (2, 'ATSM353-1紧身型', '蓝色', '2XL', '男款', 5, NULL);
INSERT INTO `stock` VALUES (3, 'ATSM353-1紧身型', '蓝色', 'L', '男款', 27, 11);
INSERT INTO `stock` VALUES (4, 'ATSM353-1紧身型', '蓝色', 'M', '男款', 17, NULL);
INSERT INTO `stock` VALUES (5, 'ATSM353-1', '蓝色', 'S', '男款', 4, NULL);
INSERT INTO `stock` VALUES (6, 'ATSM246-1', '粉色', '3XL', '女款', 2, NULL);
INSERT INTO `stock` VALUES (7, 'ATSM246-1', '粉色', 'L', '女款', 15, 2);
INSERT INTO `stock` VALUES (8, 'ATSM246-1紧身型', '粉色', 'M', '女款', 8, NULL);
INSERT INTO `stock` VALUES (9, 'ATSM246-1', '粉色', 'S', '女款', 7, NULL);
INSERT INTO `stock` VALUES (10, '运动啦啦队服', '浅蓝色', 'L', '女款', 1, NULL);
INSERT INTO `stock` VALUES (11, '运动啦啦队服', '浅蓝色', 'M', '女款', 5, NULL);
INSERT INTO `stock` VALUES (12, '运动短裤', '粉色', 'M', '女款', 2, NULL);
INSERT INTO `stock` VALUES (13, '运动短裤', '黑色', 'L', '男款', 1, NULL);
INSERT INTO `stock` VALUES (14, '背心', '粉色', 'M', '女款', 3, NULL);
INSERT INTO `stock` VALUES (15, '运动T恤', '黄绿色', '3XL', '男款', 1, NULL);
INSERT INTO `stock` VALUES (16, 'POLO衫', '浅蓝色', 'L', '男款', 4, NULL);
INSERT INTO `stock` VALUES (17, 'POLO衫', '红色', 'XL', '男款', 1, NULL);
INSERT INTO `stock` VALUES (18, 'POLO衫', '白色', 'XL', '男款', 5, NULL);
INSERT INTO `stock` VALUES (19, '运动裤', '黑色', '3XL', '男款', 1, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
  `dept_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '名称',
  `pid` bigint(20) DEFAULT NULL,
  `enabled` bit(1) NOT NULL COMMENT '状态',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `dept_sort` int(5) DEFAULT '999' COMMENT '排序',
  `sub_count` int(5) DEFAULT '0' COMMENT '子部门数目',
  `create_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`dept_id`) USING BTREE,
  KEY `idx_pid` (`pid`),
  KEY `inx_pid` (`pid`),
  KEY `inx_enabled` (`enabled`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='部门';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` VALUES (1, 'TEC云', NULL, b'1', '2019-03-01 12:07:37', 0, 3, NULL, NULL, NULL);
INSERT INTO `sys_dept` VALUES (2, '研发部', 1, b'1', '2019-03-25 09:15:32', 1, 0, NULL, NULL, NULL);
INSERT INTO `sys_dept` VALUES (3, '测试部', 1, b'1', '2019-03-25 09:52:18', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_dept` VALUES (4, '运维部', 1, b'1', '2019-03-25 09:20:44', 3, 0, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict` (
  `dict_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '字典名称',
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `create_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`dict_id`) USING BTREE,
  KEY `idx_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='数据字典';

-- ----------------------------
-- Records of sys_dict
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict` VALUES (1, 'user_status', '用户状态', '2019-10-27 20:31:36', NULL, NULL, NULL);
INSERT INTO `sys_dict` VALUES (2, 'dept_status', '部门状态', '2019-10-27 20:31:36', NULL, NULL, NULL);
INSERT INTO `sys_dict` VALUES (3, 'job_status', '岗位状态', '2019-10-27 20:31:36', NULL, NULL, NULL);
INSERT INTO `sys_dict` VALUES (4, 'size', '尺码', '2020-07-29 00:24:54', NULL, NULL, NULL);
INSERT INTO `sys_dict` VALUES (5, 'style', '男女款', '2020-07-29 00:38:40', NULL, NULL, NULL);
INSERT INTO `sys_dict` VALUES (6, 'postage_direct', '邮费支付方', '2020-08-07 00:07:20', NULL, NULL, '2020-08-07 00:07:48');
INSERT INTO `sys_dict` VALUES (7, 'bool', '是/否', '2020-08-07 00:16:13', NULL, NULL, '2020-08-07 00:16:13');
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_detail
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_detail`;
CREATE TABLE `sys_dict_detail` (
  `detail_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '字典标签',
  `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '字典值',
  `dict_sort` int(5) DEFAULT NULL COMMENT '排序',
  `dict_id` bigint(11) DEFAULT NULL COMMENT '字典id',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `create_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`detail_id`) USING BTREE,
  KEY `FK5tpkputc6d9nboxojdbgnpmyb` (`dict_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='数据字典详情';

-- ----------------------------
-- Records of sys_dict_detail
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_detail` VALUES (1, '激活', 'true', 1, 1, '2019-10-27 20:31:36', NULL, NULL, NULL);
INSERT INTO `sys_dict_detail` VALUES (2, '禁用', 'false', 2, 1, NULL, NULL, NULL, NULL);
INSERT INTO `sys_dict_detail` VALUES (3, '启用', 'true', 1, 2, NULL, NULL, NULL, NULL);
INSERT INTO `sys_dict_detail` VALUES (4, '停用', 'false', 2, 2, '2019-10-27 20:31:36', NULL, NULL, NULL);
INSERT INTO `sys_dict_detail` VALUES (5, '启用', 'true', 1, 3, NULL, NULL, NULL, NULL);
INSERT INTO `sys_dict_detail` VALUES (6, '停用', 'false', 2, 3, '2019-10-27 20:31:36', NULL, NULL, NULL);
INSERT INTO `sys_dict_detail` VALUES (7, '3XL', '3XL', 7, 4, '2020-07-29 00:25:19', NULL, NULL, NULL);
INSERT INTO `sys_dict_detail` VALUES (8, '2XL', '2XL', 6, 4, '2020-07-29 00:25:29', NULL, NULL, NULL);
INSERT INTO `sys_dict_detail` VALUES (9, 'XL', 'XL', 5, 4, '2020-07-29 00:25:44', NULL, NULL, NULL);
INSERT INTO `sys_dict_detail` VALUES (10, 'L', 'L', 4, 4, '2020-07-29 00:25:49', NULL, NULL, NULL);
INSERT INTO `sys_dict_detail` VALUES (11, 'M', 'M', 3, 4, '2020-07-29 00:25:54', NULL, NULL, NULL);
INSERT INTO `sys_dict_detail` VALUES (12, 'S', 'S', 2, 4, '2020-07-29 00:26:04', NULL, NULL, NULL);
INSERT INTO `sys_dict_detail` VALUES (13, 'XS', 'XS', 1, 4, '2020-07-29 00:26:09', NULL, NULL, NULL);
INSERT INTO `sys_dict_detail` VALUES (14, '男款', '男款', 1, 5, '2020-07-29 00:38:49', NULL, NULL, NULL);
INSERT INTO `sys_dict_detail` VALUES (15, '女款', '女款', 2, 5, '2020-07-29 00:38:58', NULL, NULL, NULL);
INSERT INTO `sys_dict_detail` VALUES (16, '不需快递', '1', 0, 6, '2020-08-07 00:08:48', NULL, NULL, '2020-08-07 00:19:56');
INSERT INTO `sys_dict_detail` VALUES (17, '寄方支付', '2', 1, 6, '2020-08-07 00:09:32', NULL, NULL, '2020-08-07 00:20:00');
INSERT INTO `sys_dict_detail` VALUES (18, '收方支付', '3', 2, 6, '2020-08-07 00:09:52', NULL, NULL, '2020-08-07 00:20:04');
INSERT INTO `sys_dict_detail` VALUES (19, '是', '1', 1, 7, '2020-08-07 00:16:22', NULL, NULL, '2020-08-07 00:16:22');
INSERT INTO `sys_dict_detail` VALUES (20, '否', '0', 0, 7, '2020-08-07 00:16:30', NULL, NULL, '2020-08-07 00:19:10');
COMMIT;

-- ----------------------------
-- Table structure for sys_job
-- ----------------------------
DROP TABLE IF EXISTS `sys_job`;
CREATE TABLE `sys_job` (
  `job_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '岗位名称',
  `enabled` bit(1) NOT NULL COMMENT '岗位状态',
  `job_sort` int(5) DEFAULT NULL COMMENT '排序',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `create_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`job_id`) USING BTREE,
  UNIQUE KEY `uniq_name` (`name`),
  KEY `inx_enabled` (`enabled`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='岗位';

-- ----------------------------
-- Records of sys_job
-- ----------------------------
BEGIN;
INSERT INTO `sys_job` VALUES (1, '全栈开发', b'1', 2, '2019-03-31 13:39:30', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
  `log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `create_time` datetime DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `exception_detail` text COLLATE utf8mb4_unicode_ci,
  `log_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `method` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `params` text COLLATE utf8mb4_unicode_ci,
  `request_ip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `time` bigint(20) DEFAULT NULL,
  `username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `browser` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`log_id`) USING BTREE,
  KEY `inx_log_type` (`log_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统日志';

-- ----------------------------
-- Records of sys_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `menu_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `i_frame` bit(1) DEFAULT NULL COMMENT '是否外链',
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '菜单标题',
  `component` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '组件',
  `pid` bigint(20) DEFAULT NULL,
  `menu_sort` int(5) DEFAULT NULL COMMENT '排序',
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图标',
  `path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '链接地址',
  `cache` bit(1) DEFAULT b'0' COMMENT '缓存',
  `hidden` bit(1) DEFAULT b'0' COMMENT '隐藏',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '组件名称',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `permission` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '权限',
  `type` int(11) DEFAULT NULL COMMENT '类型',
  `sub_count` int(5) DEFAULT '0' COMMENT '子菜单数目',
  `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新者',
  `create_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`menu_id`) USING BTREE,
  UNIQUE KEY `uniq_title` (`title`),
  UNIQUE KEY `uniq_name` (`name`),
  KEY `FKqcf9gem97gqa5qjm4d3elcqt5` (`pid`) USING BTREE,
  KEY `inx_pid` (`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=126 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统菜单';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES (1, b'0', '系统管理', NULL, NULL, 1, 'system', 'system', b'0', b'0', NULL, '2018-12-18 15:11:29', NULL, 0, 6, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (2, b'0', '用户管理', 'system/user/index', 1, 2, 'peoples', 'user', b'0', b'0', 'User', '2018-12-18 15:14:44', 'user:list', 1, 3, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (3, b'0', '角色管理', 'system/role/index', 1, 3, 'role', 'role', b'0', b'0', 'Role', '2018-12-18 15:16:07', 'roles:list', 1, 3, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (5, b'0', '菜单管理', 'system/menu/index', 1, 5, 'menu', 'menu', b'0', b'0', 'Menu', '2018-12-18 15:17:28', 'menu:list', 1, 3, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (6, b'0', '系统监控', NULL, NULL, 10, 'monitor', 'monitor', b'0', b'0', NULL, '2018-12-18 15:17:48', NULL, 0, 5, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (7, b'0', '操作日志', 'monitor/log/index', 6, 11, 'log', 'logs', b'0', b'0', 'Log', '2018-12-18 15:18:26', NULL, 1, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (9, b'0', 'SQL监控', 'monitor/sql/index', 6, 18, 'sqlMonitor', 'druid', b'0', b'0', 'Sql', '2018-12-18 15:19:34', NULL, 1, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (10, b'0', '组件管理', NULL, NULL, 50, 'zujian', 'components', b'0', b'0', NULL, '2018-12-19 13:38:16', NULL, 0, 5, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (11, b'0', '图标库', 'components/icons/index', 10, 51, 'icon', 'icon', b'0', b'0', 'Icons', '2018-12-19 13:38:49', NULL, 1, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (14, b'0', '邮件工具', 'tools/email/index', 36, 35, 'email', 'email', b'0', b'0', 'Email', '2018-12-27 10:13:09', NULL, 1, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (15, b'0', '富文本', 'components/Editor', 10, 52, 'fwb', 'tinymce', b'0', b'0', 'Editor', '2018-12-27 11:58:25', NULL, 1, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (16, b'0', '图床管理', 'tools/picture/index', 36, 33, 'image', 'pictures', b'0', b'0', 'Pictures', '2018-12-28 09:36:53', 'pictures:list', 1, 2, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (18, b'0', '存储管理', 'tools/storage/index', 36, 34, 'qiniu', 'storage', b'0', b'0', 'Storage', '2018-12-31 11:12:15', 'storage:list', 1, 3, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (19, b'0', '支付宝工具', 'tools/aliPay/index', 36, 37, 'alipay', 'aliPay', b'0', b'0', 'AliPay', '2018-12-31 14:52:38', NULL, 1, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (21, b'0', '多级菜单', '', NULL, 900, 'menu', 'nested', b'0', b'1', NULL, '2019-01-04 16:22:03', NULL, 0, 2, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (22, b'0', '二级菜单1', 'nested/menu1/index', 21, 999, 'menu', 'menu1', b'0', b'0', NULL, '2019-01-04 16:23:29', NULL, 1, 2, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (23, b'0', '二级菜单2', 'nested/menu2/index', 21, 999, 'menu', 'menu2', b'0', b'0', NULL, '2019-01-04 16:23:57', NULL, 1, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (24, b'0', '三级菜单1', 'nested/menu1/menu1-1', 22, 999, 'menu', 'menu1-1', b'0', b'0', NULL, '2019-01-04 16:24:48', NULL, 1, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (27, b'0', '三级菜单2', 'nested/menu1/menu1-2', 22, 999, 'menu', 'menu1-2', b'0', b'0', NULL, '2019-01-07 17:27:32', NULL, 1, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (28, b'0', '定时任务', 'system/timing/index', 36, 31, 'timing', 'timing', b'0', b'0', 'Timing', '2019-01-07 20:34:40', 'timing:list', 1, 3, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (30, b'0', '代码生成', 'generator/index', 36, 32, 'dev', 'generator', b'1', b'0', 'GeneratorIndex', '2019-01-11 15:45:55', NULL, 1, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (32, b'0', '异常日志', 'monitor/log/errorLog', 6, 12, 'error', 'errorLog', b'0', b'0', 'ErrorLog', '2019-01-13 13:49:03', NULL, 1, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (33, b'0', 'Markdown', 'components/MarkDown', 10, 53, 'markdown', 'markdown', b'0', b'0', 'Markdown', '2019-03-08 13:46:44', NULL, 1, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (34, b'0', 'Yaml编辑器', 'components/YamlEdit', 10, 54, 'dev', 'yaml', b'0', b'0', 'YamlEdit', '2019-03-08 15:49:40', NULL, 1, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (35, b'0', '部门管理', 'system/dept/index', 1, 6, 'dept', 'dept', b'0', b'0', 'Dept', '2019-03-25 09:46:00', 'dept:list', 1, 3, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (36, b'0', '系统工具', '', NULL, 30, 'sys-tools', 'sys-tools', b'0', b'0', NULL, '2019-03-29 10:57:35', NULL, 0, 9, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (37, b'0', '岗位管理', 'system/job/index', 1, 7, 'Steve-Jobs', 'job', b'0', b'0', 'Job', '2019-03-29 13:51:18', 'job:list', 1, 3, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (38, b'0', '接口文档', 'tools/swagger/index', 36, 36, 'swagger', 'swagger2', b'0', b'0', 'Swagger', '2019-03-29 19:57:53', NULL, 1, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (39, b'0', '字典管理', 'system/dict/index', 1, 8, 'dictionary', 'dict', b'0', b'0', 'Dict', '2019-04-10 11:49:04', 'dict:list', 1, 3, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (41, b'0', '在线用户', 'monitor/online/index', 6, 10, 'Steve-Jobs', 'online', b'0', b'0', 'OnlineUser', '2019-10-26 22:08:43', NULL, 1, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (44, b'0', '用户新增', '', 2, 2, '', '', b'0', b'0', NULL, '2019-10-29 10:59:46', 'user:add', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (45, b'0', '用户编辑', '', 2, 3, '', '', b'0', b'0', NULL, '2019-10-29 11:00:08', 'user:edit', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (46, b'0', '用户删除', '', 2, 4, '', '', b'0', b'0', NULL, '2019-10-29 11:00:23', 'user:del', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (48, b'0', '角色创建', '', 3, 2, '', '', b'0', b'0', NULL, '2019-10-29 12:45:34', 'roles:add', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (49, b'0', '角色修改', '', 3, 3, '', '', b'0', b'0', NULL, '2019-10-29 12:46:16', 'roles:edit', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (50, b'0', '角色删除', '', 3, 4, '', '', b'0', b'0', NULL, '2019-10-29 12:46:51', 'roles:del', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (52, b'0', '菜单新增', '', 5, 2, '', '', b'0', b'0', NULL, '2019-10-29 12:55:07', 'menu:add', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (53, b'0', '菜单编辑', '', 5, 3, '', '', b'0', b'0', NULL, '2019-10-29 12:55:40', 'menu:edit', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (54, b'0', '菜单删除', '', 5, 4, '', '', b'0', b'0', NULL, '2019-10-29 12:56:00', 'menu:del', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (56, b'0', '部门新增', '', 35, 2, '', '', b'0', b'0', NULL, '2019-10-29 12:57:09', 'dept:add', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (57, b'0', '部门编辑', '', 35, 3, '', '', b'0', b'0', NULL, '2019-10-29 12:57:27', 'dept:edit', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (58, b'0', '部门删除', '', 35, 4, '', '', b'0', b'0', NULL, '2019-10-29 12:57:41', 'dept:del', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (60, b'0', '岗位新增', '', 37, 2, '', '', b'0', b'0', NULL, '2019-10-29 12:58:27', 'job:add', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (61, b'0', '岗位编辑', '', 37, 3, '', '', b'0', b'0', NULL, '2019-10-29 12:58:45', 'job:edit', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (62, b'0', '岗位删除', '', 37, 4, '', '', b'0', b'0', NULL, '2019-10-29 12:59:04', 'job:del', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (64, b'0', '字典新增', '', 39, 2, '', '', b'0', b'0', NULL, '2019-10-29 13:00:17', 'dict:add', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (65, b'0', '字典编辑', '', 39, 3, '', '', b'0', b'0', NULL, '2019-10-29 13:00:42', 'dict:edit', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (66, b'0', '字典删除', '', 39, 4, '', '', b'0', b'0', NULL, '2019-10-29 13:00:59', 'dict:del', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (70, b'0', '图片上传', '', 16, 2, '', '', b'0', b'0', NULL, '2019-10-29 13:05:34', 'pictures:add', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (71, b'0', '图片删除', '', 16, 3, '', '', b'0', b'0', NULL, '2019-10-29 13:05:52', 'pictures:del', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (73, b'0', '任务新增', '', 28, 2, '', '', b'0', b'0', NULL, '2019-10-29 13:07:28', 'timing:add', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (74, b'0', '任务编辑', '', 28, 3, '', '', b'0', b'0', NULL, '2019-10-29 13:07:41', 'timing:edit', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (75, b'0', '任务删除', '', 28, 4, '', '', b'0', b'0', NULL, '2019-10-29 13:07:54', 'timing:del', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (77, b'0', '上传文件', '', 18, 2, '', '', b'0', b'0', NULL, '2019-10-29 13:09:09', 'storage:add', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (78, b'0', '文件编辑', '', 18, 3, '', '', b'0', b'0', NULL, '2019-10-29 13:09:22', 'storage:edit', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (79, b'0', '文件删除', '', 18, 4, '', '', b'0', b'0', NULL, '2019-10-29 13:09:34', 'storage:del', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (80, b'0', '服务监控', 'monitor/server/index', 6, 14, 'codeConsole', 'server', b'0', b'0', 'ServerMonitor', '2019-11-07 13:06:39', 'server:list', 1, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (82, b'0', '生成配置', 'generator/config', 36, 33, 'dev', 'generator/config/:tableName', b'1', b'1', 'GeneratorConfig', '2019-11-17 20:08:56', '', 1, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (83, b'0', '图表库', 'components/Echarts', 10, 50, 'chart', 'echarts', b'1', b'0', 'Echarts', '2019-11-21 09:04:32', '', 1, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (90, b'0', '运维管理', '', NULL, 20, 'mnt', 'mnt', b'0', b'0', 'Mnt', '2019-11-09 10:31:08', NULL, 1, 5, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (92, b'0', '服务器', 'mnt/server/index', 90, 22, 'server', 'mnt/serverDeploy', b'0', b'0', 'ServerDeploy', '2019-11-10 10:29:25', 'serverDeploy:list', 1, 3, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (93, b'0', '应用管理', 'mnt/app/index', 90, 23, 'app', 'mnt/app', b'0', b'0', 'App', '2019-11-10 11:05:16', 'app:list', 1, 3, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (94, b'0', '部署管理', 'mnt/deploy/index', 90, 24, 'deploy', 'mnt/deploy', b'0', b'0', 'Deploy', '2019-11-10 15:56:55', 'deploy:list', 1, 3, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (97, b'0', '部署备份', 'mnt/deployHistory/index', 90, 25, 'backup', 'mnt/deployHistory', b'0', b'0', 'DeployHistory', '2019-11-10 16:49:44', 'deployHistory:list', 1, 1, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (98, b'0', '数据库管理', 'mnt/database/index', 90, 26, 'database', 'mnt/database', b'0', b'0', 'Database', '2019-11-10 20:40:04', 'database:list', 1, 3, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (102, b'0', '删除', '', 97, 999, '', '', b'0', b'0', NULL, '2019-11-17 09:32:48', 'deployHistory:del', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (103, b'0', '服务器新增', '', 92, 999, '', '', b'0', b'0', NULL, '2019-11-17 11:08:33', 'serverDeploy:add', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (104, b'0', '服务器编辑', '', 92, 999, '', '', b'0', b'0', NULL, '2019-11-17 11:08:57', 'serverDeploy:edit', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (105, b'0', '服务器删除', '', 92, 999, '', '', b'0', b'0', NULL, '2019-11-17 11:09:15', 'serverDeploy:del', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (106, b'0', '应用新增', '', 93, 999, '', '', b'0', b'0', NULL, '2019-11-17 11:10:03', 'app:add', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (107, b'0', '应用编辑', '', 93, 999, '', '', b'0', b'0', NULL, '2019-11-17 11:10:28', 'app:edit', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (108, b'0', '应用删除', '', 93, 999, '', '', b'0', b'0', NULL, '2019-11-17 11:10:55', 'app:del', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (109, b'0', '部署新增', '', 94, 999, '', '', b'0', b'0', NULL, '2019-11-17 11:11:22', 'deploy:add', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (110, b'0', '部署编辑', '', 94, 999, '', '', b'0', b'0', NULL, '2019-11-17 11:11:41', 'deploy:edit', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (111, b'0', '部署删除', '', 94, 999, '', '', b'0', b'0', NULL, '2019-11-17 11:12:01', 'deploy:del', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (112, b'0', '数据库新增', '', 98, 999, '', '', b'0', b'0', NULL, '2019-11-17 11:12:43', 'database:add', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (113, b'0', '数据库编辑', '', 98, 999, '', '', b'0', b'0', NULL, '2019-11-17 11:12:58', 'database:edit', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (114, b'0', '数据库删除', '', 98, 999, '', '', b'0', b'0', NULL, '2019-11-17 11:13:14', 'database:del', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (116, b'0', '生成预览', 'generator/preview', 36, 999, 'java', 'generator/preview/:tableName', b'1', b'1', 'Preview', '2019-11-26 14:54:36', NULL, 1, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (117, b'0', '销售管理', NULL, NULL, 999, 'zujian', 'order', b'0', b'0', NULL, '2020-06-14 17:39:17', NULL, 0, 2, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (118, b'0', '库存一览', 'order/stock/index', 117, 1, 'zujian', 'order/stock', b'0', b'0', '库存管理', '2020-06-14 17:42:14', 'stock:list', 1, 3, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (119, b'0', '新增库存', NULL, 118, 999, NULL, NULL, b'0', b'0', NULL, '2020-06-14 17:46:10', 'stock:add', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (120, b'0', '修改库存', NULL, 118, 999, NULL, NULL, b'0', b'0', NULL, '2020-06-14 23:11:47', 'stock:edit', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (121, b'0', '删除库存', NULL, 118, 999, NULL, NULL, b'0', b'0', NULL, '2020-06-14 23:12:06', 'stock:del', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (122, b'0', '销售订单', 'order/bizOrder/index', 117, 999, 'list', 'api/bizOrder', b'0', b'0', '销售订单', '2020-07-25 20:04:18', 'bizOrder:list', 1, 3, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (123, b'0', '订单新增', NULL, 122, 999, NULL, NULL, b'0', b'0', NULL, '2020-07-25 20:08:44', 'bizOrder:add', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (124, b'0', '订单修改', NULL, 122, 999, NULL, NULL, b'0', b'0', NULL, '2020-07-25 20:09:11', 'bizOrder:edit', 2, 0, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (125, b'0', '订单删除', NULL, 122, 999, NULL, NULL, b'0', b'0', NULL, '2020-07-25 20:09:31', 'bizOrder:del', 2, 0, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_monitor_server
-- ----------------------------
DROP TABLE IF EXISTS `sys_monitor_server`;
CREATE TABLE `sys_monitor_server` (
  `monitor_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `cpu_core` int(11) DEFAULT NULL COMMENT 'CPU内核数',
  `cpu_rate` double DEFAULT NULL COMMENT 'CPU使用率',
  `disk_total` double DEFAULT NULL COMMENT '磁盘总量',
  `disk_used` double DEFAULT NULL COMMENT '磁盘使用量',
  `mem_total` double DEFAULT NULL COMMENT '内存总数',
  `mem_used` double DEFAULT NULL COMMENT '内存使用量',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名称',
  `port` int(11) DEFAULT NULL COMMENT '访问端口',
  `monitor_sort` int(5) DEFAULT NULL COMMENT '排序',
  `state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '状态',
  `swap_total` double DEFAULT NULL COMMENT '交换区总量',
  `swap_used` double DEFAULT NULL COMMENT '交换区使用量',
  `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '服务地址',
  `create_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`monitor_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='服务监控';

-- ----------------------------
-- Records of sys_monitor_server
-- ----------------------------
BEGIN;
INSERT INTO `sys_monitor_server` VALUES (1, 8, 0.05924018, 465.12402, 91.66521, 7.849415, 7.6052284, '本地', 8777, 999, '0', 14.599415, 11.263367, 'localhost', NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_quartz_job
-- ----------------------------
DROP TABLE IF EXISTS `sys_quartz_job`;
CREATE TABLE `sys_quartz_job` (
  `job_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `bean_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Spring Bean名称',
  `cron_expression` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'cron 表达式',
  `is_pause` bit(1) DEFAULT NULL COMMENT '状态：1暂停、0启用',
  `job_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '任务名称',
  `method_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '方法名称',
  `params` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '参数',
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `create_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `person_in_charge` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '负责人',
  `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '报警邮箱',
  `sub_task` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '子任务ID',
  `pause_after_failure` bit(1) DEFAULT NULL COMMENT '任务失败后是否暂停',
  PRIMARY KEY (`job_id`) USING BTREE,
  KEY `inx_is_pause` (`is_pause`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='定时任务';

-- ----------------------------
-- Records of sys_quartz_job
-- ----------------------------
BEGIN;
INSERT INTO `sys_quartz_job` VALUES (1, 'visitsTask', '0 0 0 * * ?', b'0', '更新访客记录', 'run', NULL, '每日0点创建新的访客记录', '2019-01-08 14:53:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_quartz_job` VALUES (2, 'testTask', '0/5 * * * * ?', b'1', '测试1', 'run1', 'test', '带参测试，多参使用json', '2019-08-22 14:08:29', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_quartz_job` VALUES (3, 'testTask', '0/5 * * * * ?', b'1', '测试', 'run', '', '不带参测试', '2019-09-26 16:44:39', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_quartz_job` VALUES (4, 'restTask', '0 0 10 * * ?', b'1', '爬虫-必应每日一图', 'run', '{\"request\":{\"url\":\"http://www.bing.com/HPImageArchive.aspx?format=js&idx=0&n=1\"},\"response\":{\"baseUrl\":\"https://www.bing.com/\",\"resolvePath\":\"images->[0]->url\",\"storeTo\":\"redis\",\"storeTarget\":\"bing-image:%s\"}}', '爬虫-必应每日一图，每天10点执行', '2020-04-28 17:26:45', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_quartz_job` VALUES (5, 'restTask', '0 0 10 * * ?', b'1', '爬虫-TECCHEN每日一句', 'run', '{\"request\":{\"url\":\"https://api.tecchen.tech/api/quote/history/random/\"},\"response\":{\"resolvePath\":\"data->content\",\"storeTo\":\"redis\",\"storeTarget\":\"tec-quote:%s\"}}', '爬虫-TECCHEN每日一句-TECCHEN', '2020-04-28 17:33:11', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_quartz_job` VALUES (6, 'restTask', '0 0 0 * * ?', b'1', '爬虫-机器人测试', 'run', '{\"request\":{\"url\":\"https://qyapi.weixin.qq.com/cgi-bin/webhook/send?key=57e862b3-6672-4252-af0e-cf1e90e68c7b\",\"params\":{\"msgtype\":\"markdown\",\"markdown\":{\"content\":\"| 序号 | 标题           |\\n| ---- | -------------- |\\n| 1    | 我是第一个标题 |\\n| 2    | 我是第二个呗   |\"}},\"method\":\"POST\"}}', '爬虫-机器人测试', '2020-04-28 18:00:20', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_quartz_job` VALUES (7, 'restTask', '0 0 10 * * ?', b'0', '爬虫-shanbay每日一句', 'run', '{\"request\":{\"url\":\"https://rest.shanbay.com/api/v2/quote/quotes/today/\"},\"response\":{\"resolvePath\":\"data->content\",\n\"storeTo\":\"redis\",\"storeTarget\":\"shanbay-quote:%s\"}}', '爬虫--shanbay每日一句', '2020-04-28 18:25:58', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_quartz_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_quartz_log`;
CREATE TABLE `sys_quartz_log` (
  `log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `bean_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Bean 名称',
  `create_time` datetime DEFAULT NULL,
  `cron_expression` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `exception_detail` text COLLATE utf8mb4_unicode_ci,
  `is_success` bit(1) DEFAULT NULL,
  `job_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `method_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `params` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `time` bigint(20) DEFAULT NULL,
  `result` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`log_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='定时任务日志';

-- ----------------------------
-- Records of sys_quartz_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `role_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '名称',
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述',
  `data_scope` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '数据权限',
  `level` int(255) DEFAULT NULL COMMENT '角色级别',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新者',
  `create_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`role_id`) USING BTREE,
  UNIQUE KEY `uniq_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='角色表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES (1, '超级管理员', '-', '全部', 1, '2018-11-23 11:04:37', NULL, NULL, NULL);
INSERT INTO `sys_role` VALUES (2, '普通用户', '-', '本级', 2, '2018-11-23 13:09:06', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_roles_depts
-- ----------------------------
DROP TABLE IF EXISTS `sys_roles_depts`;
CREATE TABLE `sys_roles_depts` (
  `role_id` bigint(20) NOT NULL,
  `dept_id` bigint(20) NOT NULL,
  PRIMARY KEY (`role_id`,`dept_id`) USING BTREE,
  KEY `FK7qg6itn5ajdoa9h9o78v9ksur` (`dept_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='角色部门关联';

-- ----------------------------
-- Records of sys_roles_depts
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_roles_menus
-- ----------------------------
DROP TABLE IF EXISTS `sys_roles_menus`;
CREATE TABLE `sys_roles_menus` (
  `menu_id` bigint(20) NOT NULL COMMENT '菜单ID',
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`menu_id`,`role_id`) USING BTREE,
  KEY `FKcngg2qadojhi3a651a5adkvbq` (`role_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='角色菜单关联';

-- ----------------------------
-- Records of sys_roles_menus
-- ----------------------------
BEGIN;
INSERT INTO `sys_roles_menus` VALUES (1, 1);
INSERT INTO `sys_roles_menus` VALUES (2, 1);
INSERT INTO `sys_roles_menus` VALUES (3, 1);
INSERT INTO `sys_roles_menus` VALUES (5, 1);
INSERT INTO `sys_roles_menus` VALUES (6, 1);
INSERT INTO `sys_roles_menus` VALUES (7, 1);
INSERT INTO `sys_roles_menus` VALUES (9, 1);
INSERT INTO `sys_roles_menus` VALUES (10, 1);
INSERT INTO `sys_roles_menus` VALUES (11, 1);
INSERT INTO `sys_roles_menus` VALUES (14, 1);
INSERT INTO `sys_roles_menus` VALUES (15, 1);
INSERT INTO `sys_roles_menus` VALUES (16, 1);
INSERT INTO `sys_roles_menus` VALUES (18, 1);
INSERT INTO `sys_roles_menus` VALUES (19, 1);
INSERT INTO `sys_roles_menus` VALUES (21, 1);
INSERT INTO `sys_roles_menus` VALUES (22, 1);
INSERT INTO `sys_roles_menus` VALUES (23, 1);
INSERT INTO `sys_roles_menus` VALUES (24, 1);
INSERT INTO `sys_roles_menus` VALUES (27, 1);
INSERT INTO `sys_roles_menus` VALUES (28, 1);
INSERT INTO `sys_roles_menus` VALUES (30, 1);
INSERT INTO `sys_roles_menus` VALUES (32, 1);
INSERT INTO `sys_roles_menus` VALUES (33, 1);
INSERT INTO `sys_roles_menus` VALUES (34, 1);
INSERT INTO `sys_roles_menus` VALUES (35, 1);
INSERT INTO `sys_roles_menus` VALUES (36, 1);
INSERT INTO `sys_roles_menus` VALUES (37, 1);
INSERT INTO `sys_roles_menus` VALUES (38, 1);
INSERT INTO `sys_roles_menus` VALUES (39, 1);
INSERT INTO `sys_roles_menus` VALUES (41, 1);
INSERT INTO `sys_roles_menus` VALUES (44, 1);
INSERT INTO `sys_roles_menus` VALUES (45, 1);
INSERT INTO `sys_roles_menus` VALUES (46, 1);
INSERT INTO `sys_roles_menus` VALUES (48, 1);
INSERT INTO `sys_roles_menus` VALUES (49, 1);
INSERT INTO `sys_roles_menus` VALUES (50, 1);
INSERT INTO `sys_roles_menus` VALUES (52, 1);
INSERT INTO `sys_roles_menus` VALUES (53, 1);
INSERT INTO `sys_roles_menus` VALUES (54, 1);
INSERT INTO `sys_roles_menus` VALUES (56, 1);
INSERT INTO `sys_roles_menus` VALUES (57, 1);
INSERT INTO `sys_roles_menus` VALUES (58, 1);
INSERT INTO `sys_roles_menus` VALUES (60, 1);
INSERT INTO `sys_roles_menus` VALUES (61, 1);
INSERT INTO `sys_roles_menus` VALUES (62, 1);
INSERT INTO `sys_roles_menus` VALUES (64, 1);
INSERT INTO `sys_roles_menus` VALUES (65, 1);
INSERT INTO `sys_roles_menus` VALUES (66, 1);
INSERT INTO `sys_roles_menus` VALUES (73, 1);
INSERT INTO `sys_roles_menus` VALUES (74, 1);
INSERT INTO `sys_roles_menus` VALUES (75, 1);
INSERT INTO `sys_roles_menus` VALUES (77, 1);
INSERT INTO `sys_roles_menus` VALUES (78, 1);
INSERT INTO `sys_roles_menus` VALUES (79, 1);
INSERT INTO `sys_roles_menus` VALUES (80, 1);
INSERT INTO `sys_roles_menus` VALUES (82, 1);
INSERT INTO `sys_roles_menus` VALUES (83, 1);
INSERT INTO `sys_roles_menus` VALUES (90, 1);
INSERT INTO `sys_roles_menus` VALUES (92, 1);
INSERT INTO `sys_roles_menus` VALUES (93, 1);
INSERT INTO `sys_roles_menus` VALUES (94, 1);
INSERT INTO `sys_roles_menus` VALUES (97, 1);
INSERT INTO `sys_roles_menus` VALUES (98, 1);
INSERT INTO `sys_roles_menus` VALUES (116, 1);
INSERT INTO `sys_roles_menus` VALUES (117, 1);
INSERT INTO `sys_roles_menus` VALUES (118, 1);
INSERT INTO `sys_roles_menus` VALUES (119, 1);
INSERT INTO `sys_roles_menus` VALUES (120, 1);
INSERT INTO `sys_roles_menus` VALUES (121, 1);
INSERT INTO `sys_roles_menus` VALUES (122, 1);
INSERT INTO `sys_roles_menus` VALUES (123, 1);
INSERT INTO `sys_roles_menus` VALUES (124, 1);
INSERT INTO `sys_roles_menus` VALUES (125, 1);
INSERT INTO `sys_roles_menus` VALUES (1, 2);
INSERT INTO `sys_roles_menus` VALUES (2, 2);
INSERT INTO `sys_roles_menus` VALUES (3, 2);
INSERT INTO `sys_roles_menus` VALUES (5, 2);
INSERT INTO `sys_roles_menus` VALUES (6, 2);
INSERT INTO `sys_roles_menus` VALUES (9, 2);
INSERT INTO `sys_roles_menus` VALUES (10, 2);
INSERT INTO `sys_roles_menus` VALUES (11, 2);
INSERT INTO `sys_roles_menus` VALUES (14, 2);
INSERT INTO `sys_roles_menus` VALUES (15, 2);
INSERT INTO `sys_roles_menus` VALUES (18, 2);
INSERT INTO `sys_roles_menus` VALUES (19, 2);
INSERT INTO `sys_roles_menus` VALUES (21, 2);
INSERT INTO `sys_roles_menus` VALUES (23, 2);
INSERT INTO `sys_roles_menus` VALUES (24, 2);
INSERT INTO `sys_roles_menus` VALUES (27, 2);
INSERT INTO `sys_roles_menus` VALUES (28, 2);
INSERT INTO `sys_roles_menus` VALUES (30, 2);
INSERT INTO `sys_roles_menus` VALUES (33, 2);
INSERT INTO `sys_roles_menus` VALUES (34, 2);
INSERT INTO `sys_roles_menus` VALUES (35, 2);
INSERT INTO `sys_roles_menus` VALUES (36, 2);
INSERT INTO `sys_roles_menus` VALUES (37, 2);
INSERT INTO `sys_roles_menus` VALUES (38, 2);
INSERT INTO `sys_roles_menus` VALUES (39, 2);
INSERT INTO `sys_roles_menus` VALUES (44, 2);
INSERT INTO `sys_roles_menus` VALUES (48, 2);
INSERT INTO `sys_roles_menus` VALUES (49, 2);
INSERT INTO `sys_roles_menus` VALUES (50, 2);
INSERT INTO `sys_roles_menus` VALUES (77, 2);
INSERT INTO `sys_roles_menus` VALUES (78, 2);
INSERT INTO `sys_roles_menus` VALUES (79, 2);
INSERT INTO `sys_roles_menus` VALUES (117, 2);
INSERT INTO `sys_roles_menus` VALUES (118, 2);
INSERT INTO `sys_roles_menus` VALUES (119, 2);
INSERT INTO `sys_roles_menus` VALUES (120, 2);
INSERT INTO `sys_roles_menus` VALUES (121, 2);
INSERT INTO `sys_roles_menus` VALUES (122, 2);
INSERT INTO `sys_roles_menus` VALUES (123, 2);
INSERT INTO `sys_roles_menus` VALUES (124, 2);
INSERT INTO `sys_roles_menus` VALUES (125, 2);
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `avatar_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '头像地址',
  `avatar_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '头像真实路径',
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '邮箱',
  `enabled` bigint(20) DEFAULT NULL COMMENT '状态：1启用、0禁用',
  `create_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新者',
  `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '密码',
  `username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户名',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '部门名称',
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '手机号码',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `is_admin` bit(1) DEFAULT b'0' COMMENT '是否为admin账号',
  `pwd_reset_time` datetime DEFAULT NULL COMMENT '修改密码的时间',
  `nick_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gender` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '性别',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`user_id`) USING BTREE,
  UNIQUE KEY `UK_kpubos9gc2cvtkb0thktkbkes` (`email`) USING BTREE,
  UNIQUE KEY `username` (`username`) USING BTREE,
  UNIQUE KEY `uniq_username` (`username`),
  UNIQUE KEY `uniq_email` (`email`),
  KEY `FK5rwmryny6jthaaxkogownknqp` (`dept_id`) USING BTREE,
  KEY `FKpq2dhypk2qgt68nauh2by22jb` (`avatar_name`) USING BTREE,
  KEY `inx_enabled` (`enabled`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统用户';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES (1, '', '', 'zhengjie@tom.com', 1, NULL, NULL, '$2a$10$fP.426qKaTmix50Oln8L.uav55gELhAd0Eg66Av4oG86u8km7D/Ky', 'admin', 2, '18888888888', '2018-08-23 09:11:56', b'1', '2019-05-18 17:34:21', '管理员', '男', '2020-07-29 22:26:29');
COMMIT;

-- ----------------------------
-- Table structure for sys_users_jobs
-- ----------------------------
DROP TABLE IF EXISTS `sys_users_jobs`;
CREATE TABLE `sys_users_jobs` (
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `job_id` bigint(20) NOT NULL COMMENT '岗位ID',
  PRIMARY KEY (`user_id`,`job_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_users_jobs
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_users_roles
-- ----------------------------
DROP TABLE IF EXISTS `sys_users_roles`;
CREATE TABLE `sys_users_roles` (
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`user_id`,`role_id`) USING BTREE,
  KEY `FKq4eq273l04bpu4efj0jd0jb98` (`role_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户角色关联';

-- ----------------------------
-- Records of sys_users_roles
-- ----------------------------
BEGIN;
INSERT INTO `sys_users_roles` VALUES (1, 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_verification_code
-- ----------------------------
DROP TABLE IF EXISTS `sys_verification_code`;
CREATE TABLE `sys_verification_code` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '验证码',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `status` bit(1) DEFAULT NULL COMMENT '状态：1有效、0过期',
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '验证码类型：email或者短信',
  `value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '接收邮箱或者手机号码',
  `scenes` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '业务名称：如重置邮箱、重置密码等',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='验证码';

-- ----------------------------
-- Records of sys_verification_code
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_visits
-- ----------------------------
DROP TABLE IF EXISTS `sys_visits`;
CREATE TABLE `sys_visits` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` datetime DEFAULT NULL,
  `date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip_counts` bigint(20) DEFAULT NULL,
  `pv_counts` bigint(20) DEFAULT NULL,
  `week_day` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `UK_11aksgq87euk9bcyeesfs4vtp` (`date`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='访客记录';

-- ----------------------------
-- Records of sys_visits
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tool_alipay_config
-- ----------------------------
DROP TABLE IF EXISTS `tool_alipay_config`;
CREATE TABLE `tool_alipay_config` (
  `config_id` bigint(20) NOT NULL COMMENT 'ID',
  `app_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '应用ID',
  `charset` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '编码',
  `format` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '类型 固定格式json',
  `gateway_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '网关地址',
  `notify_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '异步回调',
  `private_key` text COLLATE utf8mb4_unicode_ci COMMENT '私钥',
  `public_key` text COLLATE utf8mb4_unicode_ci COMMENT '公钥',
  `return_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '回调地址',
  `sign_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '签名方式',
  `sys_service_provider_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '商户号',
  PRIMARY KEY (`config_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='支付宝配置类';

-- ----------------------------
-- Records of tool_alipay_config
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tool_email_config
-- ----------------------------
DROP TABLE IF EXISTS `tool_email_config`;
CREATE TABLE `tool_email_config` (
  `config_id` bigint(20) NOT NULL COMMENT 'ID',
  `from_user` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收件人',
  `host` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '邮件服务器SMTP地址',
  `pass` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '密码',
  `port` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '端口',
  `user` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '发件者用户名',
  PRIMARY KEY (`config_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='邮箱配置';

-- ----------------------------
-- Records of tool_email_config
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tool_local_storage
-- ----------------------------
DROP TABLE IF EXISTS `tool_local_storage`;
CREATE TABLE `tool_local_storage` (
  `storage_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `real_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件真实的名称',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件名',
  `suffix` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '后缀',
  `path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '路径',
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '类型',
  `size` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '大小',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `create_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`storage_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='本地存储';

-- ----------------------------
-- Records of tool_local_storage
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tool_picture
-- ----------------------------
DROP TABLE IF EXISTS `tool_picture`;
CREATE TABLE `tool_picture` (
  `picture_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `create_time` datetime DEFAULT NULL COMMENT '上传日期',
  `delete_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '删除的URL',
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图片名称',
  `height` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图片高度',
  `size` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图片大小',
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图片地址',
  `username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户名称',
  `width` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图片宽度',
  `md5code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件的MD5值',
  PRIMARY KEY (`picture_id`) USING BTREE,
  UNIQUE KEY `uniq_md5_code` (`md5code`),
  KEY `inx_url` (`url`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Sm.Ms图床';

-- ----------------------------
-- Records of tool_picture
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tool_qiniu_config
-- ----------------------------
DROP TABLE IF EXISTS `tool_qiniu_config`;
CREATE TABLE `tool_qiniu_config` (
  `config_id` bigint(20) NOT NULL COMMENT 'ID',
  `access_key` text COLLATE utf8mb4_unicode_ci COMMENT 'accessKey',
  `bucket` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Bucket 识别符',
  `host` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '外链域名',
  `secret_key` text COLLATE utf8mb4_unicode_ci COMMENT 'secretKey',
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '空间类型',
  `zone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '机房',
  PRIMARY KEY (`config_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='七牛云配置';

-- ----------------------------
-- Records of tool_qiniu_config
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tool_qiniu_content
-- ----------------------------
DROP TABLE IF EXISTS `tool_qiniu_content`;
CREATE TABLE `tool_qiniu_content` (
  `content_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `bucket` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Bucket 识别符',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件名称',
  `size` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件大小',
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件类型：私有或公开',
  `update_time` datetime DEFAULT NULL COMMENT '上传或同步的时间',
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件url',
  `suffix` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`content_id`) USING BTREE,
  UNIQUE KEY `uniq_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='七牛云文件存储';

-- ----------------------------
-- Records of tool_qiniu_content
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
